<h1 class="top">Other function</h1>
<h2>The block</h2>
<img src="help/img/other_if.png" alt="other function" class="leftFloatIMG">
<p class="leftFloat left">
    This blcok block has varius functions. You can test
    <a href="#if" class="groupLinks">if</a> somthing is true or false,if somthing is
    <a href="#nvl" class="groupLinks">null</a> or if somthing is 
    You can <a href="#greater"  class="groupLinks">greater</a> or, 
    <a href="#greater"  class="groupLinks">less</a>. 
    It ist used in the 'Select'-section. 
    The values you use with the function are the subselect, 
    the green table and column block, the table and column value block, the compare operator, all type variables.
    Exept of the <a href="#if" class="groupLinks">if</a> function, all the functions changes the colour to simbolise the 
    <a href="#types" class="groupLinks">type</a>.  <span style="font-weight: bold;">Notice:</span> The <a href="#if" class="groupLinks">if</a> is always cyan, symbolising type bool.

<h2> Functions</h2>
<h3 id="if">IF</h3>
<img src="help/img/other_if.png" alt="Function if" class="rightFloatIMG" style="margin-top:12px;">
<p class="text">The if function uses as first value every time the compare operator.<br>  Its the Statement you want to be true or false. The second input is the value, which will be choosed if the statement is true, the second if the statement is false.<br>You use this function, if you want to search somthing in the "SELECT"-Statement.<br> A simple example is shown below. </p>
<img src="help/img/other_if_use.png" alt="Function to date" class="img" >
<h3  id="greater">Greater and less</h3>
<img src="help/img/other_least.png" alt="Function gretaer and less" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The greater and the least function use as value the green table and column block. The mimum number of values you have to plug in is two.<br> If you want to plugin more blocks, just klick on the <span style="color:#A00;">star-icon</span>.Then add "New Input"-blocks to the "ADD"-block. The Block now will expand. This is shown in the picture below.</p>
<img src="help/img/other_least_mutate.png" alt="Function gretaer and less" class="rightFloatIMG" >
<h3  id="nvl">If null</h3>
<img src="help/img/other_ifnull.png" alt="Function to date" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The if null function uses as first value either one of the groupfunctions, a subselect or the green table column block.<br>  Its the Statement you want to be null. The second input is the value, which will be choosed if the statement is null<br>You use this function, if you want to search for null values in your tables.<br> A simple example is shown below. </p>
<img src="help/img/other_ifnull_use.png" alt="Function to date" class="img" >
<h2 id="types">The types</h2>
<img src="help/img/other_int.png" alt="Type numeric" class="img" style="margin-top: 10px;">
<p class="text"> This colour,violet,  symbolises the numeric values of the database</p>
<img src="help/img/other_text.png" alt="Type text" class="img">
<p class="text"> This colour, brown, symbolises the textual values of the database</p>
<img src="help/img/other_date.png" alt="Type date" class="img">
<p class="text"> This colour,tapestry, symbolises the date values of the database</p>
<img src="help/img/o_bool.png" alt="Type bool" class="img">
<p class="text"> This colour ,cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>